Blue
White
Purple
Green
Red
Orange
Blue Light
White Light
Purple Light
Green Light
Red Light
Orange Light
hiSQL code helpUpdate the existing table field according to the value of a different table---------------------SELECTdaire.id,daire.blok,daire.daire_no,daire.daire_tipi,daire.dairem2,daire.blok_adi,daire.dolu,(UPDATE daire SET daire.dolu='1' WHERE sakinler.aktif='1') FROM daire, sakinler
You cannot do select and update in the same query. If you are looking for an update that uses values from another table check examples here:https://stackoverflow.com/questions/1262786/mysql-update-query-based-on-select-query